Dataset Introduction

The Masterdata contains dataset section as follows:-

A Dataset is a collection of data of one or more columns from a single table or multiple tables organized for processing by business intelligence software to extract meaningful information and generate reports, charts, maps and create different visualization.📈

The source of the data can vary depending on how the organization are managing their data, It can be a JDBC, Flat file, Web service, etc. regardless of how the data is stored, once the connection bridge is built between the Database and OPNBI (OPNBI) user can create different datasets relevant to different departments and users within the organization.📊

Dataset tab can be accessed by clicking on Dataset or by clicking on next to the Dataset tab, which will open the Dataset in a new tab. Dataset and other sections under the MasterData tab are only visible if the appropriate privileges have been assigned to the logged in user, please contact your administrator if you facing difficulties accessing the sections under the Masterdata tab.

💻 Using the Datasets section user can perform the following tasks:-

Create dataset in OPNBI, using the required datasource as follows from the tutorial below 📁:

Know more about Create dataset.

Edit dataset after creating and applying in dashboard, now to edit dataset by following the tutorial below:

⚙️ Edit dataset.

Follow below tutorial to know Dashboard Download, Upload, Version & Audit check:

🔽 Download dataset.

🔼 Upload dataset.

🆚 version dataset.

📑 Audit dataset.

Following tutorial to Copy, Move and Delete:

🚹 Copy dataset.

Ⓜ️ Move dataset.

🚮 Delete dataset.

Following tutorial to schedule dataset:

⏩ Schedule Dataset.

ℹ️ Property of dataset.

🚻 Share.

Following tutorial to Archive & Purge dataset:

🚁 Dataset UnArchive.

🚀 Dataset UnPurge.

More features of Masterdata as follows:

Create datasource

Create datasource mapping

Group Dataset

Create Parameter

To know more about advance feature of Dateset Section click on below links:-

DML with Multiple join Condition

External Dataset